package com.pgybook.db.entity.domain;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class StaffEx {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public StaffEx() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andStaffidIsNull() {
            addCriterion("STAFFID is null");
            return (Criteria) this;
        }

        public Criteria andStaffidIsNotNull() {
            addCriterion("STAFFID is not null");
            return (Criteria) this;
        }

        public Criteria andStaffidEqualTo(Integer value) {
            addCriterion("STAFFID =", value, "staffid");
            return (Criteria) this;
        }

        public Criteria andStaffidNotEqualTo(Integer value) {
            addCriterion("STAFFID <>", value, "staffid");
            return (Criteria) this;
        }

        public Criteria andStaffidGreaterThan(Integer value) {
            addCriterion("STAFFID >", value, "staffid");
            return (Criteria) this;
        }

        public Criteria andStaffidGreaterThanOrEqualTo(Integer value) {
            addCriterion("STAFFID >=", value, "staffid");
            return (Criteria) this;
        }

        public Criteria andStaffidLessThan(Integer value) {
            addCriterion("STAFFID <", value, "staffid");
            return (Criteria) this;
        }

        public Criteria andStaffidLessThanOrEqualTo(Integer value) {
            addCriterion("STAFFID <=", value, "staffid");
            return (Criteria) this;
        }

        public Criteria andStaffidIn(List<Integer> values) {
            addCriterion("STAFFID in", values, "staffid");
            return (Criteria) this;
        }

        public Criteria andStaffidNotIn(List<Integer> values) {
            addCriterion("STAFFID not in", values, "staffid");
            return (Criteria) this;
        }

        public Criteria andStaffidBetween(Integer value1, Integer value2) {
            addCriterion("STAFFID between", value1, value2, "staffid");
            return (Criteria) this;
        }

        public Criteria andStaffidNotBetween(Integer value1, Integer value2) {
            addCriterion("STAFFID not between", value1, value2, "staffid");
            return (Criteria) this;
        }

        public Criteria andDeptIdIsNull() {
            addCriterion("DEPT_ID is null");
            return (Criteria) this;
        }

        public Criteria andDeptIdIsNotNull() {
            addCriterion("DEPT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andDeptIdEqualTo(Integer value) {
            addCriterion("DEPT_ID =", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotEqualTo(Integer value) {
            addCriterion("DEPT_ID <>", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdGreaterThan(Integer value) {
            addCriterion("DEPT_ID >", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("DEPT_ID >=", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdLessThan(Integer value) {
            addCriterion("DEPT_ID <", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdLessThanOrEqualTo(Integer value) {
            addCriterion("DEPT_ID <=", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdIn(List<Integer> values) {
            addCriterion("DEPT_ID in", values, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotIn(List<Integer> values) {
            addCriterion("DEPT_ID not in", values, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdBetween(Integer value1, Integer value2) {
            addCriterion("DEPT_ID between", value1, value2, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotBetween(Integer value1, Integer value2) {
            addCriterion("DEPT_ID not between", value1, value2, "deptId");
            return (Criteria) this;
        }

        public Criteria andEmployeenumIsNull() {
            addCriterion("EMPLOYEENUM is null");
            return (Criteria) this;
        }

        public Criteria andEmployeenumIsNotNull() {
            addCriterion("EMPLOYEENUM is not null");
            return (Criteria) this;
        }

        public Criteria andEmployeenumEqualTo(String value) {
            addCriterion("EMPLOYEENUM =", value, "employeenum");
            return (Criteria) this;
        }

        public Criteria andEmployeenumNotEqualTo(String value) {
            addCriterion("EMPLOYEENUM <>", value, "employeenum");
            return (Criteria) this;
        }

        public Criteria andEmployeenumGreaterThan(String value) {
            addCriterion("EMPLOYEENUM >", value, "employeenum");
            return (Criteria) this;
        }

        public Criteria andEmployeenumGreaterThanOrEqualTo(String value) {
            addCriterion("EMPLOYEENUM >=", value, "employeenum");
            return (Criteria) this;
        }

        public Criteria andEmployeenumLessThan(String value) {
            addCriterion("EMPLOYEENUM <", value, "employeenum");
            return (Criteria) this;
        }

        public Criteria andEmployeenumLessThanOrEqualTo(String value) {
            addCriterion("EMPLOYEENUM <=", value, "employeenum");
            return (Criteria) this;
        }

        public Criteria andEmployeenumLike(String value) {
            addCriterion("EMPLOYEENUM like", value, "employeenum");
            return (Criteria) this;
        }

        public Criteria andEmployeenumNotLike(String value) {
            addCriterion("EMPLOYEENUM not like", value, "employeenum");
            return (Criteria) this;
        }

        public Criteria andEmployeenumIn(List<String> values) {
            addCriterion("EMPLOYEENUM in", values, "employeenum");
            return (Criteria) this;
        }

        public Criteria andEmployeenumNotIn(List<String> values) {
            addCriterion("EMPLOYEENUM not in", values, "employeenum");
            return (Criteria) this;
        }

        public Criteria andEmployeenumBetween(String value1, String value2) {
            addCriterion("EMPLOYEENUM between", value1, value2, "employeenum");
            return (Criteria) this;
        }

        public Criteria andEmployeenumNotBetween(String value1, String value2) {
            addCriterion("EMPLOYEENUM not between", value1, value2, "employeenum");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("NAME is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("NAME is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("NAME =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("NAME <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("NAME >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("NAME >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("NAME <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("NAME <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("NAME like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("NAME not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("NAME in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("NAME not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("NAME between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("NAME not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andCellphone1IsNull() {
            addCriterion("CELLPHONE1 is null");
            return (Criteria) this;
        }

        public Criteria andCellphone1IsNotNull() {
            addCriterion("CELLPHONE1 is not null");
            return (Criteria) this;
        }

        public Criteria andCellphone1EqualTo(String value) {
            addCriterion("CELLPHONE1 =", value, "cellphone1");
            return (Criteria) this;
        }

        public Criteria andCellphone1NotEqualTo(String value) {
            addCriterion("CELLPHONE1 <>", value, "cellphone1");
            return (Criteria) this;
        }

        public Criteria andCellphone1GreaterThan(String value) {
            addCriterion("CELLPHONE1 >", value, "cellphone1");
            return (Criteria) this;
        }

        public Criteria andCellphone1GreaterThanOrEqualTo(String value) {
            addCriterion("CELLPHONE1 >=", value, "cellphone1");
            return (Criteria) this;
        }

        public Criteria andCellphone1LessThan(String value) {
            addCriterion("CELLPHONE1 <", value, "cellphone1");
            return (Criteria) this;
        }

        public Criteria andCellphone1LessThanOrEqualTo(String value) {
            addCriterion("CELLPHONE1 <=", value, "cellphone1");
            return (Criteria) this;
        }

        public Criteria andCellphone1Like(String value) {
            addCriterion("CELLPHONE1 like", value, "cellphone1");
            return (Criteria) this;
        }

        public Criteria andCellphone1NotLike(String value) {
            addCriterion("CELLPHONE1 not like", value, "cellphone1");
            return (Criteria) this;
        }

        public Criteria andCellphone1In(List<String> values) {
            addCriterion("CELLPHONE1 in", values, "cellphone1");
            return (Criteria) this;
        }

        public Criteria andCellphone1NotIn(List<String> values) {
            addCriterion("CELLPHONE1 not in", values, "cellphone1");
            return (Criteria) this;
        }

        public Criteria andCellphone1Between(String value1, String value2) {
            addCriterion("CELLPHONE1 between", value1, value2, "cellphone1");
            return (Criteria) this;
        }

        public Criteria andCellphone1NotBetween(String value1, String value2) {
            addCriterion("CELLPHONE1 not between", value1, value2, "cellphone1");
            return (Criteria) this;
        }

        public Criteria andCellphone2IsNull() {
            addCriterion("CELLPHONE2 is null");
            return (Criteria) this;
        }

        public Criteria andCellphone2IsNotNull() {
            addCriterion("CELLPHONE2 is not null");
            return (Criteria) this;
        }

        public Criteria andCellphone2EqualTo(String value) {
            addCriterion("CELLPHONE2 =", value, "cellphone2");
            return (Criteria) this;
        }

        public Criteria andCellphone2NotEqualTo(String value) {
            addCriterion("CELLPHONE2 <>", value, "cellphone2");
            return (Criteria) this;
        }

        public Criteria andCellphone2GreaterThan(String value) {
            addCriterion("CELLPHONE2 >", value, "cellphone2");
            return (Criteria) this;
        }

        public Criteria andCellphone2GreaterThanOrEqualTo(String value) {
            addCriterion("CELLPHONE2 >=", value, "cellphone2");
            return (Criteria) this;
        }

        public Criteria andCellphone2LessThan(String value) {
            addCriterion("CELLPHONE2 <", value, "cellphone2");
            return (Criteria) this;
        }

        public Criteria andCellphone2LessThanOrEqualTo(String value) {
            addCriterion("CELLPHONE2 <=", value, "cellphone2");
            return (Criteria) this;
        }

        public Criteria andCellphone2Like(String value) {
            addCriterion("CELLPHONE2 like", value, "cellphone2");
            return (Criteria) this;
        }

        public Criteria andCellphone2NotLike(String value) {
            addCriterion("CELLPHONE2 not like", value, "cellphone2");
            return (Criteria) this;
        }

        public Criteria andCellphone2In(List<String> values) {
            addCriterion("CELLPHONE2 in", values, "cellphone2");
            return (Criteria) this;
        }

        public Criteria andCellphone2NotIn(List<String> values) {
            addCriterion("CELLPHONE2 not in", values, "cellphone2");
            return (Criteria) this;
        }

        public Criteria andCellphone2Between(String value1, String value2) {
            addCriterion("CELLPHONE2 between", value1, value2, "cellphone2");
            return (Criteria) this;
        }

        public Criteria andCellphone2NotBetween(String value1, String value2) {
            addCriterion("CELLPHONE2 not between", value1, value2, "cellphone2");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("EMAIL is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("EMAIL is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("EMAIL =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("EMAIL <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("EMAIL >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("EMAIL >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("EMAIL <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("EMAIL <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("EMAIL like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("EMAIL not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("EMAIL in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("EMAIL not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("EMAIL between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("EMAIL not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNull() {
            addCriterion("PASSWORD is null");
            return (Criteria) this;
        }

        public Criteria andPasswordIsNotNull() {
            addCriterion("PASSWORD is not null");
            return (Criteria) this;
        }

        public Criteria andPasswordEqualTo(String value) {
            addCriterion("PASSWORD =", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotEqualTo(String value) {
            addCriterion("PASSWORD <>", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThan(String value) {
            addCriterion("PASSWORD >", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("PASSWORD >=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThan(String value) {
            addCriterion("PASSWORD <", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLessThanOrEqualTo(String value) {
            addCriterion("PASSWORD <=", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordLike(String value) {
            addCriterion("PASSWORD like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotLike(String value) {
            addCriterion("PASSWORD not like", value, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordIn(List<String> values) {
            addCriterion("PASSWORD in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotIn(List<String> values) {
            addCriterion("PASSWORD not in", values, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordBetween(String value1, String value2) {
            addCriterion("PASSWORD between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andPasswordNotBetween(String value1, String value2) {
            addCriterion("PASSWORD not between", value1, value2, "password");
            return (Criteria) this;
        }

        public Criteria andIssaIsNull() {
            addCriterion("ISSA is null");
            return (Criteria) this;
        }

        public Criteria andIssaIsNotNull() {
            addCriterion("ISSA is not null");
            return (Criteria) this;
        }

        public Criteria andIssaEqualTo(Integer value) {
            addCriterion("ISSA =", value, "issa");
            return (Criteria) this;
        }

        public Criteria andIssaNotEqualTo(Integer value) {
            addCriterion("ISSA <>", value, "issa");
            return (Criteria) this;
        }

        public Criteria andIssaGreaterThan(Integer value) {
            addCriterion("ISSA >", value, "issa");
            return (Criteria) this;
        }

        public Criteria andIssaGreaterThanOrEqualTo(Integer value) {
            addCriterion("ISSA >=", value, "issa");
            return (Criteria) this;
        }

        public Criteria andIssaLessThan(Integer value) {
            addCriterion("ISSA <", value, "issa");
            return (Criteria) this;
        }

        public Criteria andIssaLessThanOrEqualTo(Integer value) {
            addCriterion("ISSA <=", value, "issa");
            return (Criteria) this;
        }

        public Criteria andIssaIn(List<Integer> values) {
            addCriterion("ISSA in", values, "issa");
            return (Criteria) this;
        }

        public Criteria andIssaNotIn(List<Integer> values) {
            addCriterion("ISSA not in", values, "issa");
            return (Criteria) this;
        }

        public Criteria andIssaBetween(Integer value1, Integer value2) {
            addCriterion("ISSA between", value1, value2, "issa");
            return (Criteria) this;
        }

        public Criteria andIssaNotBetween(Integer value1, Integer value2) {
            addCriterion("ISSA not between", value1, value2, "issa");
            return (Criteria) this;
        }

        public Criteria andIssuIsNull() {
            addCriterion("ISSU is null");
            return (Criteria) this;
        }

        public Criteria andIssuIsNotNull() {
            addCriterion("ISSU is not null");
            return (Criteria) this;
        }

        public Criteria andIssuEqualTo(Integer value) {
            addCriterion("ISSU =", value, "issu");
            return (Criteria) this;
        }

        public Criteria andIssuNotEqualTo(Integer value) {
            addCriterion("ISSU <>", value, "issu");
            return (Criteria) this;
        }

        public Criteria andIssuGreaterThan(Integer value) {
            addCriterion("ISSU >", value, "issu");
            return (Criteria) this;
        }

        public Criteria andIssuGreaterThanOrEqualTo(Integer value) {
            addCriterion("ISSU >=", value, "issu");
            return (Criteria) this;
        }

        public Criteria andIssuLessThan(Integer value) {
            addCriterion("ISSU <", value, "issu");
            return (Criteria) this;
        }

        public Criteria andIssuLessThanOrEqualTo(Integer value) {
            addCriterion("ISSU <=", value, "issu");
            return (Criteria) this;
        }

        public Criteria andIssuIn(List<Integer> values) {
            addCriterion("ISSU in", values, "issu");
            return (Criteria) this;
        }

        public Criteria andIssuNotIn(List<Integer> values) {
            addCriterion("ISSU not in", values, "issu");
            return (Criteria) this;
        }

        public Criteria andIssuBetween(Integer value1, Integer value2) {
            addCriterion("ISSU between", value1, value2, "issu");
            return (Criteria) this;
        }

        public Criteria andIssuNotBetween(Integer value1, Integer value2) {
            addCriterion("ISSU not between", value1, value2, "issu");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("STATUS is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("STATUS =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("STATUS <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("STATUS >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("STATUS >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("STATUS <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("STATUS <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("STATUS in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("STATUS not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("STATUS between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("STATUS not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andCrttimeIsNull() {
            addCriterion("CRTTIME is null");
            return (Criteria) this;
        }

        public Criteria andCrttimeIsNotNull() {
            addCriterion("CRTTIME is not null");
            return (Criteria) this;
        }

        public Criteria andCrttimeEqualTo(Date value) {
            addCriterion("CRTTIME =", value, "crttime");
            return (Criteria) this;
        }

        public Criteria andCrttimeNotEqualTo(Date value) {
            addCriterion("CRTTIME <>", value, "crttime");
            return (Criteria) this;
        }

        public Criteria andCrttimeGreaterThan(Date value) {
            addCriterion("CRTTIME >", value, "crttime");
            return (Criteria) this;
        }

        public Criteria andCrttimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CRTTIME >=", value, "crttime");
            return (Criteria) this;
        }

        public Criteria andCrttimeLessThan(Date value) {
            addCriterion("CRTTIME <", value, "crttime");
            return (Criteria) this;
        }

        public Criteria andCrttimeLessThanOrEqualTo(Date value) {
            addCriterion("CRTTIME <=", value, "crttime");
            return (Criteria) this;
        }

        public Criteria andCrttimeIn(List<Date> values) {
            addCriterion("CRTTIME in", values, "crttime");
            return (Criteria) this;
        }

        public Criteria andCrttimeNotIn(List<Date> values) {
            addCriterion("CRTTIME not in", values, "crttime");
            return (Criteria) this;
        }

        public Criteria andCrttimeBetween(Date value1, Date value2) {
            addCriterion("CRTTIME between", value1, value2, "crttime");
            return (Criteria) this;
        }

        public Criteria andCrttimeNotBetween(Date value1, Date value2) {
            addCriterion("CRTTIME not between", value1, value2, "crttime");
            return (Criteria) this;
        }

        public Criteria andUpttimeIsNull() {
            addCriterion("UPTTIME is null");
            return (Criteria) this;
        }

        public Criteria andUpttimeIsNotNull() {
            addCriterion("UPTTIME is not null");
            return (Criteria) this;
        }

        public Criteria andUpttimeEqualTo(Date value) {
            addCriterion("UPTTIME =", value, "upttime");
            return (Criteria) this;
        }

        public Criteria andUpttimeNotEqualTo(Date value) {
            addCriterion("UPTTIME <>", value, "upttime");
            return (Criteria) this;
        }

        public Criteria andUpttimeGreaterThan(Date value) {
            addCriterion("UPTTIME >", value, "upttime");
            return (Criteria) this;
        }

        public Criteria andUpttimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPTTIME >=", value, "upttime");
            return (Criteria) this;
        }

        public Criteria andUpttimeLessThan(Date value) {
            addCriterion("UPTTIME <", value, "upttime");
            return (Criteria) this;
        }

        public Criteria andUpttimeLessThanOrEqualTo(Date value) {
            addCriterion("UPTTIME <=", value, "upttime");
            return (Criteria) this;
        }

        public Criteria andUpttimeIn(List<Date> values) {
            addCriterion("UPTTIME in", values, "upttime");
            return (Criteria) this;
        }

        public Criteria andUpttimeNotIn(List<Date> values) {
            addCriterion("UPTTIME not in", values, "upttime");
            return (Criteria) this;
        }

        public Criteria andUpttimeBetween(Date value1, Date value2) {
            addCriterion("UPTTIME between", value1, value2, "upttime");
            return (Criteria) this;
        }

        public Criteria andUpttimeNotBetween(Date value1, Date value2) {
            addCriterion("UPTTIME not between", value1, value2, "upttime");
            return (Criteria) this;
        }

        public Criteria andCrtstaffIsNull() {
            addCriterion("CRTSTAFF is null");
            return (Criteria) this;
        }

        public Criteria andCrtstaffIsNotNull() {
            addCriterion("CRTSTAFF is not null");
            return (Criteria) this;
        }

        public Criteria andCrtstaffEqualTo(Integer value) {
            addCriterion("CRTSTAFF =", value, "crtstaff");
            return (Criteria) this;
        }

        public Criteria andCrtstaffNotEqualTo(Integer value) {
            addCriterion("CRTSTAFF <>", value, "crtstaff");
            return (Criteria) this;
        }

        public Criteria andCrtstaffGreaterThan(Integer value) {
            addCriterion("CRTSTAFF >", value, "crtstaff");
            return (Criteria) this;
        }

        public Criteria andCrtstaffGreaterThanOrEqualTo(Integer value) {
            addCriterion("CRTSTAFF >=", value, "crtstaff");
            return (Criteria) this;
        }

        public Criteria andCrtstaffLessThan(Integer value) {
            addCriterion("CRTSTAFF <", value, "crtstaff");
            return (Criteria) this;
        }

        public Criteria andCrtstaffLessThanOrEqualTo(Integer value) {
            addCriterion("CRTSTAFF <=", value, "crtstaff");
            return (Criteria) this;
        }

        public Criteria andCrtstaffIn(List<Integer> values) {
            addCriterion("CRTSTAFF in", values, "crtstaff");
            return (Criteria) this;
        }

        public Criteria andCrtstaffNotIn(List<Integer> values) {
            addCriterion("CRTSTAFF not in", values, "crtstaff");
            return (Criteria) this;
        }

        public Criteria andCrtstaffBetween(Integer value1, Integer value2) {
            addCriterion("CRTSTAFF between", value1, value2, "crtstaff");
            return (Criteria) this;
        }

        public Criteria andCrtstaffNotBetween(Integer value1, Integer value2) {
            addCriterion("CRTSTAFF not between", value1, value2, "crtstaff");
            return (Criteria) this;
        }

        public Criteria andUptstaffIsNull() {
            addCriterion("UPTSTAFF is null");
            return (Criteria) this;
        }

        public Criteria andUptstaffIsNotNull() {
            addCriterion("UPTSTAFF is not null");
            return (Criteria) this;
        }

        public Criteria andUptstaffEqualTo(Integer value) {
            addCriterion("UPTSTAFF =", value, "uptstaff");
            return (Criteria) this;
        }

        public Criteria andUptstaffNotEqualTo(Integer value) {
            addCriterion("UPTSTAFF <>", value, "uptstaff");
            return (Criteria) this;
        }

        public Criteria andUptstaffGreaterThan(Integer value) {
            addCriterion("UPTSTAFF >", value, "uptstaff");
            return (Criteria) this;
        }

        public Criteria andUptstaffGreaterThanOrEqualTo(Integer value) {
            addCriterion("UPTSTAFF >=", value, "uptstaff");
            return (Criteria) this;
        }

        public Criteria andUptstaffLessThan(Integer value) {
            addCriterion("UPTSTAFF <", value, "uptstaff");
            return (Criteria) this;
        }

        public Criteria andUptstaffLessThanOrEqualTo(Integer value) {
            addCriterion("UPTSTAFF <=", value, "uptstaff");
            return (Criteria) this;
        }

        public Criteria andUptstaffIn(List<Integer> values) {
            addCriterion("UPTSTAFF in", values, "uptstaff");
            return (Criteria) this;
        }

        public Criteria andUptstaffNotIn(List<Integer> values) {
            addCriterion("UPTSTAFF not in", values, "uptstaff");
            return (Criteria) this;
        }

        public Criteria andUptstaffBetween(Integer value1, Integer value2) {
            addCriterion("UPTSTAFF between", value1, value2, "uptstaff");
            return (Criteria) this;
        }

        public Criteria andUptstaffNotBetween(Integer value1, Integer value2) {
            addCriterion("UPTSTAFF not between", value1, value2, "uptstaff");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}